This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Sep 27, 2012, 4:01 PM
10 Posts

SQL General Error when doing UPDATE on MS Access file

  • Category: Debugging
  • Platform: Windows
  • Release: 8.5.3
  • Role:
  • Tags: Access Java XPages
  • Replies: 0
I am using a Java class to access MS Access database from Xpages.  I debug the Java using JCreator and it works there.  I have SELECT, INSERT, and DELETE queries that all work, but UPDATE throws a SQLException: General Exception.  I used PreparedStatement, and then simplified it using just Statement with no parameters (i.e. UPDATE table SET First_Name = 'What' WHERE Last_Name = 'Who') with the same result, so it seems like it is UPDATE it doesn't like.  Any suggestions?

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal